package com.yangit.temp.util.pdf.test;

import java.awt.Color;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

import com.lowagie.text.Document;
import com.lowagie.text.DocumentException;
import com.lowagie.text.Font;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.BaseFont;
import com.lowagie.text.pdf.PdfPCell;
import com.lowagie.text.pdf.PdfPTable;
import com.lowagie.text.pdf.PdfWriter;

/**
 *- 利用 iText 实现 PDF 报表下载 (没有用flying saucer)
 * @author Administrator
 *
 */
public class ReportServlet extends HttpServlet {
       
    /**
     * Return a PDF document for download.
     * 
     */
    public void doGet (HttpServletRequest request, HttpServletResponse response)
    throws IOException, ServletException {
        String account_id = request.getParameter("account_id");
        String search_date_from = request.getParameter("search_date_from");
        String to = request.getParameter("to");
        WebApplicationContext ctx = WebApplicationContextUtils.getWebApplicationContext(this.getServletContext());
        UserService userService = new UserService();
        List<Map<String, Object>> list = userService.getAccountActivity(account_id, search_date_from, to);
        // create PDF document
        Document document = new Document();
        try {
            //set response info
            response.setContentType("application/x-msdownload;charset=UTF-8");
            response.setHeader("Content-Disposition","attachment;filename=report.pdf");
            //open output stream
            PdfWriter.getInstance(document, response.getOutputStream());
            // open PDF document
            document.open();
            // set chinese font
            BaseFont bfChinese = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", BaseFont.NOT_EMBEDDED);  
            Font f2 = new Font(bfChinese, 2, Font.NORMAL);
            Font f6 = new Font(bfChinese, 6, Font.NORMAL);
            Font f8 = new Font(bfChinese, 8, Font.NORMAL);
            Font f10 = new Font(bfChinese, 10, Font.NORMAL);
            Font f12 = new Font(bfChinese, 12, Font.BOLD);
            //set title
            document.add(new Paragraph("金融报表", f12)); 
            //<br>
            document.add(new Paragraph(" ",f6)); 
            //set sub title
            document.add(new Paragraph("账户信息", f10)); 
            //<br>
            document.add(new Paragraph(" ", f2));
            //process business data
            if(list.size()>0 && list.get(0).get("bankbook_no")!=null){
                float openBalance = 0;
                //create table with 7 columns
                PdfPTable table = new PdfPTable(7);
                //100% width
                table.setWidthPercentage(100);
                table.setHorizontalAlignment(PdfPTable.ALIGN_LEFT);
                //create cells
                PdfPCell cell = new PdfPCell();
                //set color
                cell.setBackgroundColor(new Color(213, 141, 69));
                cell.setHorizontalAlignment(PdfPCell.ALIGN_CENTER);
                //
                cell.setPhrase(new Paragraph("交易日", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("类型", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("备注", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("ID", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("票号", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("合计", f8));
                table.addCell(cell);
                cell.setPhrase(new Paragraph("余额", f8));
                table.addCell(cell);
                //create another cell
                PdfPCell newcell = new PdfPCell();
                newcell.setHorizontalAlignment(PdfPCell.ALIGN_CENTER);
                
                Map<String, Object> map = new HashMap<String, Object>();
                for(int i = 0; i < list.size(); i++){
                    map = list.get(i);
                    String cashInout = map.get("cash_inout").toString();
                    newcell.setPhrase(new Paragraph(map.get("trade_date").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(map.get("bankbook_type").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(map.get("memo").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(map.get("account_id").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(map.get("ticket_no").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(map.get("amount").toString(), f8));
                    table.addCell(newcell);
                    newcell.setPhrase(new Paragraph(openBalance+"", f8));
                    table.addCell(newcell);
                    if(cashInout.equals("I")){
                        openBalance = openBalance + Float.valueOf(map.get("amount").toString());
                    }else if(cashInout.equals("O")){
                        openBalance = openBalance - Float.valueOf(map.get("amount").toString());
                    }
                }
                //print total column
                newcell.setPhrase(new Paragraph("合计"+openBalance, f8));
                table.addCell("");
                table.addCell("");
                table.addCell("");
                table.addCell("");
                table.addCell("");
                table.addCell("");
                table.addCell(newcell);
                document.add(table);
            }else{
                PdfPTable table = new PdfPTable(1);
                table.setWidthPercentage(100);
                table.setHorizontalAlignment(PdfPTable.ALIGN_LEFT);
                PdfPCell cell = new PdfPCell(new Paragraph("暂无数据"));
                cell.setHorizontalAlignment(PdfPCell.ALIGN_CENTER);
                table.addCell(cell);
                document.add(table);
            }
        }
        catch(DocumentException de) {
            de.printStackTrace();
            System.err.println("document: " + de.getMessage());
        }finally{
            // close the document and the outputstream is also closed internally
            document.close();
        }        
    }
}

class UserService {

	public List<Map<String, Object>> getAccountActivity(String account_id, String search_date_from, String to) {
		// TODO Auto-generated method stub
		return null;
	}

}
